CREATE VIEW [dbo].[vSoaGroupSummaryOrganization]
WITH SCHEMABINDING
AS
    SELECT  'ORGRELATIONSHIP-' + [n].[ID] AS [GroupId],
            'Party' AS [ParentEntityTypeName],
            [n].[ID] AS [ParentEntityId],
            'ORGRELATIONSHIP' AS [GroupClassId],
            [n].[COMPANY] AS [Name]
      FROM  [dbo].[Name] AS [n]
     WHERE  [n].[COMPANY_RECORD] = 1

GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupSummaryOrganization] ON [dbo].[vSoaGroupSummaryOrganization] ([GroupId]) ON [PRIMARY]
GO